﻿using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using GoogleEarthClasses.Global;
namespace GoogleEarthClasses.Data
{
    public static class DColor
    {
        public static DataTable SelectAll()
        {
            SqlDataAdapter _DataAdapter = null;
            try
            {
                _DataAdapter = new SqlDataAdapter("sp_Color_SelectAll", DBHelper.GetConnection());
                _DataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                DataTable _Dt = new DataTable();
                _DataAdapter.Fill(_Dt);
                return _Dt;
            }
            catch (SqlException sex)
            {
                throw sex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (_DataAdapter != null) _DataAdapter.SelectCommand.Connection.Close();
            }
        }

    }
}



